﻿CREATE TABLE [dbo].[Requirement] (
    [ID]                   INT          IDENTITY (1, 1) NOT NULL,
    [Name]                 VARCHAR (50) NOT NULL,
    [Type]                 INT          NOT NULL,
    [AssetTypeID]          INT          NOT NULL,
    [FrequencyType]        INT          NOT NULL,
    [Frequency]            INT          NULL,
    [FrequencyDueEnd]      INT          NULL,
    [UseNotHolidayWeekday] BIT          NOT NULL,
    [UseHoliday]           BIT          NOT NULL,
    [FirstTime]            DATETIME     NULL,
    [SecondTime]           DATETIME     NULL,
    [CreatedDate]          DATETIME     NOT NULL,
    [CreatedBy]            INT          NOT NULL,
    [UseSaturdays]         BIT          NOT NULL,
    [UseSundays]           BIT          NOT NULL
);

